
































  
  


  

  
  	
  

  

	
	

	
	
	
	
	




  
















	
	
	
	
	
	
	
	
	
	
  
  


	


	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	




    
  






  
    
  




	
	
	
	
	



<!--NewPage-->
<HTML>

<!-- Mirrored from delerium:8503/cfcdoc/content.cfm?file=C%3A%5CInetpub%5Cwwwroot%5Ctransfer%2Droot%5Ctransfer%5Ccom%5Csql%5CTransferGateway%2Ecfc by HTTrack Website Copier/3.x [XR&CO'2006], Sat, 07 Apr 2007 03:17:38 GMT -->
<!-- Added by HTTrack --><meta http-equiv="content-type" content="text/html;charset=UTF-8"><!-- /Added by HTTrack -->
<HEAD>

<!-- Generated by CFDoc on 07-Apr-2007 01:17 PM -->

<LINK REL ="stylesheet" TYPE="text/css" HREF="stylesheet.css" TITLE="Style">
</HEAD>
<BODY>


	



<HR>
<!-- ======== START OF CLASS DATA ======== -->

<div style="float:left;">

<a href="default.html" style="float: right;">Documentation home page</a>
</div>
<H2>
<span style="font-size: smaller">
<a href="components3650.html" target="components">transfer.com.sql</a>
</span>
<BR>
Component TransferGateway</H2>


<PRE>
<B>transfer.com.sql.TransferGateway</B>
</PRE>


<HR>
Dynamically develops SQL for gateway calls


<HR>

<P>


<!-- ========== PROPERTY SUMMARY =========== -->

<A NAME="property_summary"><!-- --></A>






<!-- ========== METHOD SUMMARY =========== -->




<A NAME="method_summary"><!-- --></A>

<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">

<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=2><FONT SIZE="+2">
<B>Method Summary</B></FONT></TD>
</TR>











	





	





	





	





	





	





	





	





	





	





	





	





	





	



	<TR BGCOLOR="eeeeff" CLASS="TableRowColorConstructor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="content503d.html" target="_self">TransferGateway</a></CODE></TD>
	<TD><CODE><B><A HREF="#init()">init</A></B>(<a href="content2efb.html">Datasource</a> datasource,&nbsp;<a href="content7dd0.html">ObjectManager</a> objectManager,&nbsp;<a href="content41fe.html">TQLConverter</a> tQLConverter)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Constructor
	</TD>
	</TR>
	

	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="content2efb.html" target="_self">Datasource</a></CODE></TD>
	<TD><CODE><B><A HREF="#getDatasource()">getDatasource</A></B>()</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="content7dd0.html" target="_self">ObjectManager</a></CODE></TD>
	<TD><CODE><B><A HREF="#getObjectManager()">getObjectManager</A></B>()</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="content41fe.html" target="_self">TQLConverter</a></CODE></TD>
	<TD><CODE><B><A HREF="#getTQLConverter()">getTQLConverter</A></B>()</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_query" target="_self">query</a></CODE></TD>
	<TD><CODE><B><A HREF="#list()">list</A></B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lists a series of object values
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_query" target="_self">query</a></CODE></TD>
	<TD><CODE><B><A HREF="#listByProperty()">listByProperty</A></B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;<a href="nativetypes.html#detail_string">string</a> propertyName,&nbsp;<a href="nativetypes.html#detail_any">any</a> propertyValue,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lists a series of values, filtered by a given value
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_query" target="_self">query</a></CODE></TD>
	<TD><CODE><B><A HREF="#listByPropertyMap()">listByPropertyMap</A></B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;<a href="nativetypes.html#detail_struct">struct</a> propertyMap,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lists values, filtered by a Struct of Property : Value properties
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_query" target="_self">query</a></CODE></TD>
	<TD><CODE><B><A HREF="#listByWhere()">listByWhere</A></B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;<a href="nativetypes.html#detail_any">any</a> whereSQL,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lists a series of values, filtered by a given value
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#setDatasource()">setDatasource</A></B>(<a href="content2efb.html">Datasource</a> Datasource)</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#setObjectManager()">setObjectManager</A></B>(<a href="content7dd0.html">ObjectManager</a> ObjectManager)</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#setTQLConverter()">setTQLConverter</A></B>(<a href="content41fe.html">TQLConverter</a> TQLConverter)</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_any" target="_self">any</a></CODE></TD>
	<TD><CODE><B><A HREF="#throw()">throw</A></B>(<a href="nativetypes.html#detail_string">string</a> type,&nbsp;<a href="nativetypes.html#detail_string">string</a> message,&nbsp;[<a href="nativetypes.html#detail_string">string</a> detail=""])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Throws an Exception
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#writeOrderBySQL()">writeOrderBySQL</A></B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="nativetypes.html#detail_string">string</a> orderProperty,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> orderASC)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Writes the order by SQL
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#writeSelectFromSQL()">writeSelectFromSQL</A></B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> useAliases)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Writes the select and from SQL
	
	
	</TD>
	</TR>
	
</TABLE>



&nbsp;
<P>



<!-- ============ METHOD DETAIL ========== -->


<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Method Detail</B></FONT></TD>
</TR>
</TABLE>












<A NAME="getDatasource()"><!-- --></A><H3>
getDatasource</H3>

<PRE>
private <A HREF="content2efb.html" title="">Datasource</A> <B>getDatasource</B>()</PRE>
<DL>
  <DD>
  	
  	
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getObjectManager()"><!-- --></A><H3>
getObjectManager</H3>

<PRE>
private <A HREF="content7dd0.html" title="">transfer.com.object.ObjectManager</A> <B>getObjectManager</B>()</PRE>
<DL>
  <DD>
  	
  	
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getTQLConverter()"><!-- --></A><H3>
getTQLConverter</H3>

<PRE>
private <A HREF="content41fe.html" title="">transfer.com.sql.TQLConverter</A> <B>getTQLConverter</B>()</PRE>
<DL>
  <DD>
  	
  	
	
	
    
  </DD>
</DL>
<HR>




<A NAME="init()"><!-- --></A><H3>
init</H3>

<PRE>
public <A HREF="content503d.html" title="">TransferGateway</A> <B>init</B>(<a href="content2efb.html">Datasource</a> datasource,&nbsp;<a href="content7dd0.html">ObjectManager</a> objectManager,&nbsp;<a href="content41fe.html">TQLConverter</a> tQLConverter)</PRE>
<DL>
  <DD>
  	
  	
		Constructor
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content2efb.html">Datasource</a> datasource</code> - The datasource BO</DD>
			
			  <DD><code><a href="content7dd0.html">ObjectManager</a> objectManager</code> - Need to object manager for making queries</DD>
			
			  <DD><code><a href="content41fe.html">TQLConverter</a> tQLConverter</code> - Converter for {property} statements</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="list()"><!-- --></A><H3>
list</H3>

<PRE>
public <A HREF="nativetypes.html#detail_query" title="">query</A> <B>list</B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</PRE>
<DL>
  <DD>
  	
  	
		Lists a series of object values
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> className</code> - The class of the objects to list</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> orderProperty=""]</code> - The property to order by</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"]</code> - Boolean whether to order by ASC, otherwise order by DESC</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"]</code> - Boolean as to whether or not to alias columns with the transfer property names</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="listByProperty()"><!-- --></A><H3>
listByProperty</H3>

<PRE>
public <A HREF="nativetypes.html#detail_query" title="">query</A> <B>listByProperty</B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;<a href="nativetypes.html#detail_string">string</a> propertyName,&nbsp;<a href="nativetypes.html#detail_any">any</a> propertyValue,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</PRE>
<DL>
  <DD>
  	
  	
		Lists a series of values, filtered by a given value
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> className</code> - The class of the objects to list</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> propertyName</code> - The name of the property to filter by</DD>
			
			  <DD><code><a href="nativetypes.html#detail_any">any</a> propertyValue</code> - The value to filter by (only simple values)</DD>
			
			  <DD><code><a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey</code> - boolean to whether or not to only retrieve the primary key</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> orderProperty=""]</code> - The property to order by</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"]</code> - Boolean whether to order by ASC, otherwise order by DESC</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"]</code> - Boolean as to whether or not to alias columns with the transfer property names</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="listByPropertyMap()"><!-- --></A><H3>
listByPropertyMap</H3>

<PRE>
public <A HREF="nativetypes.html#detail_query" title="">query</A> <B>listByPropertyMap</B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;<a href="nativetypes.html#detail_struct">struct</a> propertyMap,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</PRE>
<DL>
  <DD>
  	
  	
		Lists values, filtered by a Struct of Property : Value properties
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> className</code> - The class of the objects to list</DD>
			
			  <DD><code><a href="nativetypes.html#detail_struct">struct</a> propertyMap</code> - Struct with keys that match to properties, and values to filter by</DD>
			
			  <DD><code><a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey</code> - boolean to whether or not to only retrieve the primary key</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> orderProperty=""]</code> - The property to order by</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"]</code> - Boolean whether to order by ASC, otherwise order by DESC</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"]</code> - Boolean as to whether or not to alias columns with the transfer property names</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="listByWhere()"><!-- --></A><H3>
listByWhere</H3>

<PRE>
public <A HREF="nativetypes.html#detail_query" title="">query</A> <B>listByWhere</B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;<a href="nativetypes.html#detail_any">any</a> whereSQL,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</PRE>
<DL>
  <DD>
  	
  	
		Lists a series of values, filtered by a given value
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> className</code> - The class of the objects to list</DD>
			
			  <DD><code><a href="nativetypes.html#detail_any">any</a> whereSQL</code> - The where statement for the SQL Query (Do not include the 'where'). Properties can be defined as {propertyName}</DD>
			
			  <DD><code><a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey</code> - boolean to whether or not to only retrieve the primary key</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> orderProperty=""]</code> - The property to order by</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"]</code> - Boolean whether to order by ASC, otherwise order by DESC</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"]</code> - Boolean as to whether or not to alias columns with the transfer property names</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="setDatasource()"><!-- --></A><H3>
setDatasource</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>setDatasource</B>(<a href="content2efb.html">Datasource</a> Datasource)</PRE>
<DL>
  <DD>
  	
  	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content2efb.html">Datasource</a> Datasource</code></DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="setObjectManager()"><!-- --></A><H3>
setObjectManager</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>setObjectManager</B>(<a href="content7dd0.html">ObjectManager</a> ObjectManager)</PRE>
<DL>
  <DD>
  	
  	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7dd0.html">ObjectManager</a> ObjectManager</code></DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="setTQLConverter()"><!-- --></A><H3>
setTQLConverter</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>setTQLConverter</B>(<a href="content41fe.html">TQLConverter</a> TQLConverter)</PRE>
<DL>
  <DD>
  	
  	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content41fe.html">TQLConverter</a> TQLConverter</code></DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="throw()"><!-- --></A><H3>
throw</H3>

<PRE>
private <A HREF="nativetypes.html#detail_any" title="">any</A> <B>throw</B>(<a href="nativetypes.html#detail_string">string</a> type,&nbsp;<a href="nativetypes.html#detail_string">string</a> message,&nbsp;[<a href="nativetypes.html#detail_string">string</a> detail=""])</PRE>
<DL>
  <DD>
  	
  	
		Throws an Exception
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> type</code> - The type of exception</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> message</code> - The message to accompany the exception</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> detail=""]</code> - The detail message for the exception</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="writeOrderBySQL()"><!-- --></A><H3>
writeOrderBySQL</H3>

<PRE>
private <A HREF="nativetypes.html#detail_string" title="">string</A> <B>writeOrderBySQL</B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="nativetypes.html#detail_string">string</a> orderProperty,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> orderASC)</PRE>
<DL>
  <DD>
  	
  	
		Writes the order by SQL
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The object the properties are read from</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> orderProperty</code> - The property to order by</DD>
			
			  <DD><code><a href="nativetypes.html#detail_boolean">boolean</a> orderASC</code> - Boolean whether to order by ASC, otherwise order by DESC</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="writeSelectFromSQL()"><!-- --></A><H3>
writeSelectFromSQL</H3>

<PRE>
private <A HREF="nativetypes.html#detail_string" title="">string</A> <B>writeSelectFromSQL</B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> useAliases)</PRE>
<DL>
  <DD>
  	
  	
		Writes the select and from SQL
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The object to be listing</DD>
			
			  <DD><code><a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey</code> - boolean to whether or not to only retrieve the primary key</DD>
			
			  <DD><code><a href="nativetypes.html#detail_boolean">boolean</a> useAliases</code> - Boolean as to whether or not to alias columns with the transfer property names</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>







</BODY>

<!-- Mirrored from delerium:8503/cfcdoc/content.cfm?file=C%3A%5CInetpub%5Cwwwroot%5Ctransfer%2Droot%5Ctransfer%5Ccom%5Csql%5CTransferGateway%2Ecfc by HTTrack Website Copier/3.x [XR&CO'2006], Sat, 07 Apr 2007 03:17:38 GMT -->
<!-- Added by HTTrack --><meta http-equiv="content-type" content="text/html;charset=UTF-8"><!-- /Added by HTTrack -->
</HTML>